﻿--TBL_BRANCH: danh sách trung tâm SME

exec('
delete from  TBL_BRANCH
insert TBL_BRANCH
SELECT BRANCH_ID,BRANCH_CODE_SME,BRANCH_NAME_SME,ZONE_ID_SME as REGION,CITY --into TBL_BRANCH
 FROM SERVER74.BICDATA.DBO.BRANCH_CODE
WHERE ZONE_ID_SME LIKE ''%V%'' or ZONE_ID_SME like ''%MBD%''')


--select * from TBL_BRANCH